Profiling Report

Dataset statistics

Number of variables	24
Number of observations	3000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	562.6 KiB
Average record size in memory	192.0 B

Variable types

Text	1
Categorical	14
Numeric	8
DateTime	1

Alerts

`gross_margin_percentage` has constant value ""	Constant
`branch` is highly overall correlated with `branch_name` and 4 other fields	High correlation
`branch_name` is highly overall correlated with `branch` and 4 other fields	High correlation
`city` is highly overall correlated with `branch` and 4 other fields	High correlation
`city_manager_first_name` is highly overall correlated with `branch` and 4 other fields	High correlation
`city_manager_last_name` is highly overall correlated with `branch` and 4 other fields	High correlation
`cogs` is highly overall correlated with `gross_income` and 4 other fields	High correlation
`gross_income` is highly overall correlated with `cogs` and 4 other fields	High correlation
`manager_name` is highly overall correlated with `branch` and 4 other fields	High correlation
`product_code` is highly overall correlated with `product_line`	High correlation
`product_line` is highly overall correlated with `product_code`	High correlation
`quantity` is highly overall correlated with `cogs` and 3 other fields	High correlation
`tax_5%` is highly overall correlated with `cogs` and 4 other fields	High correlation
`total` is highly overall correlated with `cogs` and 4 other fields	High correlation
`unit_price` is highly overall correlated with `cogs` and 3 other fields	High correlation
`year_of_txn` is uniformly distributed	Uniform

Reproduction

Analysis started	2024-03-21 09:54:54.699414
Analysis finished	2024-03-21 09:55:09.104290
Duration	14.4 seconds
Software version	ydata-profiling vv4.7.0
Download configuration	config.json

invoice_id
Text

Distinct	1000
Distinct (%)	33.3%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	33000
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	155-45-3814
2nd row	810-60-6344
3rd row	431-66-2305
4th row	189-52-0236
5th row	575-67-1508

Value	Count	Frequency (%)
155-45-3814	3	0.1%
669-54-1719	3	0.1%
831-81-6575	3	0.1%
377-79-7592	3	0.1%
431-66-2305	3	0.1%
189-52-0236	3	0.1%
575-67-1508	3	0.1%
250-81-7186	3	0.1%
416-17-9926	3	0.1%
740-11-5257	3	0.1%
Other values (990)	2970	99.0%

Most occurring characters

Value	Count	Frequency (%)
-	6000	18.2%
2	2871	8.7%
6	2862	8.7%
1	2850	8.6%
8	2832	8.6%
5	2781	8.4%
4	2754	8.3%
3	2727	8.3%
7	2685	8.1%
0	2427	7.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	33000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	6000	18.2%
2	2871	8.7%
6	2862	8.7%
1	2850	8.6%
8	2832	8.6%
5	2781	8.4%
4	2754	8.3%
3	2727	8.3%
7	2685	8.1%
0	2427	7.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	33000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	6000	18.2%
2	2871	8.7%
6	2862	8.7%
1	2850	8.6%
8	2832	8.6%
5	2781	8.4%
4	2754	8.3%
3	2727	8.3%
7	2685	8.1%
0	2427	7.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	33000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	6000	18.2%
2	2871	8.7%
6	2862	8.7%
1	2850	8.6%
8	2832	8.6%
5	2781	8.4%
4	2754	8.3%
3	2727	8.3%
7	2685	8.1%
0	2427	7.4%

branch
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

A	1020
B	996
C	984

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	3000
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C
2nd row	C
3rd row	B
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	1020	34.0%
B	996	33.2%
C	984	32.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	1020	34.0%
b	996	33.2%
c	984	32.8%

Most occurring characters

Value	Count	Frequency (%)
A	1020	34.0%
B	996	33.2%
C	984	32.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	1020	34.0%
B	996	33.2%
C	984	32.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	1020	34.0%
B	996	33.2%
C	984	32.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	1020	34.0%
B	996	33.2%
C	984	32.8%

city
Categorical

HIGH CORRELATION

Distinct	9
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Yangon	1011
Mandalay	988
Naypyitaw	978
Detroit	5
Lakeland	4
Other values (4)	14

Length

Max length	10
Median length	9
Mean length	7.654
Min length	6

Characters and Unicode

Total characters	22962
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Naypyitaw
2nd row	Naypyitaw
3rd row	Mandalay
4th row	Yangon
5th row	Yangon

Common Values

Value	Count	Frequency (%)
Yangon	1011	33.7%
Mandalay	988	32.9%
Naypyitaw	978	32.6%
Detroit	5	0.2%
Lakeland	4	0.1%
Fairfield	4	0.1%
Manhattan	4	0.1%
Chicago	3	0.1%
Metropolis	3	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
yangon	1011	33.7%
mandalay	988	32.9%
naypyitaw	978	32.6%
detroit	5	0.2%
lakeland	4	0.1%
fairfield	4	0.1%
manhattan	4	0.1%
chicago	3	0.1%
metropolis	3	0.1%

Most occurring characters

Value	Count	Frequency (%)
a	5958	25.9%
n	3022	13.2%
y	2944	12.8%
o	1025	4.5%
g	1014	4.4%
Y	1011	4.4%
l	999	4.4%
t	999	4.4%
i	997	4.3%
d	996	4.3%
Other values (15)	3997	17.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	22962	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	5958	25.9%
n	3022	13.2%
y	2944	12.8%
o	1025	4.5%
g	1014	4.4%
Y	1011	4.4%
l	999	4.4%
t	999	4.4%
i	997	4.3%
d	996	4.3%
Other values (15)	3997	17.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	22962	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	5958	25.9%
n	3022	13.2%
y	2944	12.8%
o	1025	4.5%
g	1014	4.4%
Y	1011	4.4%
l	999	4.4%
t	999	4.4%
i	997	4.3%
d	996	4.3%
Other values (15)	3997	17.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	22962	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	5958	25.9%
n	3022	13.2%
y	2944	12.8%
o	1025	4.5%
g	1014	4.4%
Y	1011	4.4%
l	999	4.4%
t	999	4.4%
i	997	4.3%
d	996	4.3%
Other values (15)	3997	17.4%

customer_type
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Member	1503
Normal	1497

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	18000
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Member
2nd row	Normal
3rd row	Normal
4th row	Normal
5th row	Normal

Common Values

Value	Count	Frequency (%)
Member	1503	50.1%
Normal	1497	49.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
member	1503	50.1%
normal	1497	49.9%

Most occurring characters

Value	Count	Frequency (%)
e	3006	16.7%
m	3000	16.7%
r	3000	16.7%
M	1503	8.3%
b	1503	8.3%
N	1497	8.3%
o	1497	8.3%
a	1497	8.3%
l	1497	8.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	18000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	3006	16.7%
m	3000	16.7%
r	3000	16.7%
M	1503	8.3%
b	1503	8.3%
N	1497	8.3%
o	1497	8.3%
a	1497	8.3%
l	1497	8.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	18000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	3006	16.7%
m	3000	16.7%
r	3000	16.7%
M	1503	8.3%
b	1503	8.3%
N	1497	8.3%
o	1497	8.3%
a	1497	8.3%
l	1497	8.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	18000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	3006	16.7%
m	3000	16.7%
r	3000	16.7%
M	1503	8.3%
b	1503	8.3%
N	1497	8.3%
o	1497	8.3%
a	1497	8.3%
l	1497	8.3%

gender
Categorical

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Female	1503
Male	1497

Length

Max length	6
Median length	6
Mean length	5.002
Min length	4

Characters and Unicode

Total characters	15006
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Female
2nd row	Female
3rd row	Female
4th row	Male
5th row	Male

Common Values

Value	Count	Frequency (%)
Female	1503	50.1%
Male	1497	49.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
female	1503	50.1%
male	1497	49.9%

Most occurring characters

Value	Count	Frequency (%)
e	4503	30.0%
a	3000	20.0%
l	3000	20.0%
F	1503	10.0%
m	1503	10.0%
M	1497	10.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15006	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	4503	30.0%
a	3000	20.0%
l	3000	20.0%
F	1503	10.0%
m	1503	10.0%
M	1497	10.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15006	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	4503	30.0%
a	3000	20.0%
l	3000	20.0%
F	1503	10.0%
m	1503	10.0%
M	1497	10.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15006	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	4503	30.0%
a	3000	20.0%
l	3000	20.0%
F	1503	10.0%
m	1503	10.0%
M	1497	10.0%

product_line
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Fashion accessories	534
Food and beverages	522
Electronic accessories	510
Sports and travel	498
Home and lifestyle	480

Length

Max length	22
Median length	19
Mean length	18.54
Min length	17

Characters and Unicode

Total characters	55620
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Electronic accessories
2nd row	Electronic accessories
3rd row	Electronic accessories
4th row	Electronic accessories
5th row	Electronic accessories

Common Values

Value	Count	Frequency (%)
Fashion accessories	534	17.8%
Food and beverages	522	17.4%
Electronic accessories	510	17.0%
Sports and travel	498	16.6%
Home and lifestyle	480	16.0%
Health and beauty	456	15.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
and	1956	24.6%
accessories	1044	13.1%
fashion	534	6.7%
food	522	6.6%
beverages	522	6.6%
electronic	510	6.4%
sports	498	6.3%
travel	498	6.3%
home	480	6.0%
lifestyle	480	6.0%
Other values (2)	912	11.5%

Most occurring characters

Value	Count	Frequency (%)
e	7014	12.6%
a	5466	9.8%
s	5166	9.3%
	4956	8.9%
o	4110	7.4%
c	3108	5.6%
r	3072	5.5%
n	3000	5.4%
t	2898	5.2%
i	2568	4.6%
Other values (15)	14262	25.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	55620	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	7014	12.6%
a	5466	9.8%
s	5166	9.3%
	4956	8.9%
o	4110	7.4%
c	3108	5.6%
r	3072	5.5%
n	3000	5.4%
t	2898	5.2%
i	2568	4.6%
Other values (15)	14262	25.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	55620	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	7014	12.6%
a	5466	9.8%
s	5166	9.3%
	4956	8.9%
o	4110	7.4%
c	3108	5.6%
r	3072	5.5%
n	3000	5.4%
t	2898	5.2%
i	2568	4.6%
Other values (15)	14262	25.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	55620	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	7014	12.6%
a	5466	9.8%
s	5166	9.3%
	4956	8.9%
o	4110	7.4%
c	3108	5.6%
r	3072	5.5%
n	3000	5.4%
t	2898	5.2%
i	2568	4.6%
Other values (15)	14262	25.6%

unit_price
Real number (ℝ)

HIGH CORRELATION

Distinct	943
Distinct (%)	31.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55.67213

Minimum	10.08
Maximum	99.96
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	10.08
5-th percentile	15.279
Q1	32.875
median	55.23
Q3	77.935
95-th percentile	97.222
Maximum	99.96
Range	89.88
Interquartile range (IQR)	45.06

Descriptive statistics

Standard deviation	26.485792
Coefficient of variation (CV)	0.47574599
Kurtosis	-1.2185316
Mean	55.67213
Median Absolute Deviation (MAD)	22.505
Skewness	0.0070703629
Sum	167016.39
Variance	701.4972
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
83.77	9	0.3%
48.63	6	0.2%
89.48	6	0.2%
84.05	6	0.2%
51.34	6	0.2%
34.42	6	0.2%
39.62	6	0.2%
87.87	6	0.2%
23.75	6	0.2%
73.47	6	0.2%
Other values (933)	2937	97.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10.08	3	0.1%
10.13	3	0.1%
10.16	3	0.1%
10.17	3	0.1%
10.18	3	0.1%
10.53	3	0.1%
10.56	3	0.1%
10.59	3	0.1%
10.69	3	0.1%
10.75	3	0.1%

Value	Count	Frequency (%)
99.96	6	0.2%
99.92	3	0.1%
99.89	3	0.1%
99.83	3	0.1%
99.82	6	0.2%
99.79	3	0.1%
99.78	3	0.1%
99.73	3	0.1%
99.71	3	0.1%
99.7	3	0.1%

quantity
Real number (ℝ)

HIGH CORRELATION

Distinct	10
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.51

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	8
95-th percentile	10
Maximum	10
Range	9
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.9224556
Coefficient of variation (CV)	0.53039122
Kurtosis	-1.2154975
Mean	5.51
Median Absolute Deviation (MAD)	2
Skewness	0.012928093
Sum	16530
Variance	8.5407469
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10	357	11.9%
1	336	11.2%
4	327	10.9%
7	306	10.2%
5	306	10.2%
6	294	9.8%
9	276	9.2%
2	273	9.1%
3	270	9.0%
8	255	8.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	336	11.2%
2	273	9.1%
3	270	9.0%
4	327	10.9%
5	306	10.2%
6	294	9.8%
7	306	10.2%
8	255	8.5%
9	276	9.2%
10	357	11.9%

Value	Count	Frequency (%)
10	357	11.9%
9	276	9.2%
8	255	8.5%
7	306	10.2%
6	294	9.8%
5	306	10.2%
4	327	10.9%
3	270	9.0%
2	273	9.1%
1	336	11.2%

tax_5%
Real number (ℝ)

HIGH CORRELATION

Distinct	990
Distinct (%)	33.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.379369

Minimum	0.5085
Maximum	49.65
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	0.5085
5-th percentile	1.955725
Q1	5.924875
median	12.088
Q3	22.44525
95-th percentile	39.1665
Maximum	49.65
Range	49.1415
Interquartile range (IQR)	16.520375

Descriptive statistics

Standard deviation	11.704921
Coefficient of variation (CV)	0.76107938
Kurtosis	-0.085613201
Mean	15.379369
Median Absolute Deviation (MAD)	7.50875
Skewness	0.89167629
Sum	46138.107
Variance	137.00517
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.57	6	0.2%
39.48	6	0.2%
8.377	6	0.2%
13.188	6	0.2%
10.326	6	0.2%
10.3635	6	0.2%
22.428	6	0.2%
4.464	6	0.2%
4.154	6	0.2%
9.0045	6	0.2%
Other values (980)	2940	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.5085	3	0.1%
0.6045	3	0.1%
0.627	3	0.1%
0.639	3	0.1%
0.699	3	0.1%
0.767	3	0.1%
0.7715	3	0.1%
0.775	3	0.1%
0.814	3	0.1%
0.8875	3	0.1%

Value	Count	Frequency (%)
49.65	3	0.1%
49.49	3	0.1%
49.26	3	0.1%
48.75	3	0.1%
48.69	3	0.1%
48.685	3	0.1%
48.605	3	0.1%
47.79	3	0.1%
47.72	3	0.1%
45.325	3	0.1%

total
Real number (ℝ)

HIGH CORRELATION

Distinct	990
Distinct (%)	33.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	322.96675

Minimum	10.6785
Maximum	1042.65
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	10.6785
5-th percentile	41.070225
Q1	124.42238
median	253.848
Q3	471.35025
95-th percentile	822.4965
Maximum	1042.65
Range	1031.9715
Interquartile range (IQR)	346.92787

Descriptive statistics

Standard deviation	245.80333
Coefficient of variation (CV)	0.76107938
Kurtosis	-0.085613201
Mean	322.96675
Median Absolute Deviation (MAD)	157.68375
Skewness	0.89167629
Sum	968900.25
Variance	60419.278
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
263.97	6	0.2%
829.08	6	0.2%
175.917	6	0.2%
276.948	6	0.2%
216.846	6	0.2%
217.6335	6	0.2%
470.988	6	0.2%
93.744	6	0.2%
87.234	6	0.2%
189.0945	6	0.2%
Other values (980)	2940	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10.6785	3	0.1%
12.6945	3	0.1%
13.167	3	0.1%
13.419	3	0.1%
14.679	3	0.1%
16.107	3	0.1%
16.2015	3	0.1%
16.275	3	0.1%
17.094	3	0.1%
18.6375	3	0.1%

Value	Count	Frequency (%)
1042.65	3	0.1%
1039.29	3	0.1%
1034.46	3	0.1%
1023.75	3	0.1%
1022.49	3	0.1%
1022.385	3	0.1%
1020.705	3	0.1%
1003.59	3	0.1%
1002.12	3	0.1%
951.825	3	0.1%

time
Date

Distinct	506
Distinct (%)	16.9%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Minimum	2024-03-21 10:00:00
Maximum	2024-03-21 20:59:00

Histogram

Histogram with fixed size bins (bins=50)

payment
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Ewallet	1035
Cash	1032
Credit card	933

Length

Max length	11
Median length	7
Mean length	7.212
Min length	4

Characters and Unicode

Total characters	21636
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Ewallet
2nd row	Credit card
3rd row	Credit card
4th row	Cash
5th row	Ewallet

Common Values

Value	Count	Frequency (%)
Ewallet	1035	34.5%
Cash	1032	34.4%
Credit card	933	31.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ewallet	1035	26.3%
cash	1032	26.2%
credit	933	23.7%
card	933	23.7%

Most occurring characters

Value	Count	Frequency (%)
a	3000	13.9%
l	2070	9.6%
e	1968	9.1%
t	1968	9.1%
C	1965	9.1%
r	1866	8.6%
d	1866	8.6%
E	1035	4.8%
w	1035	4.8%
s	1032	4.8%
Other values (4)	3831	17.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21636	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	3000	13.9%
l	2070	9.6%
e	1968	9.1%
t	1968	9.1%
C	1965	9.1%
r	1866	8.6%
d	1866	8.6%
E	1035	4.8%
w	1035	4.8%
s	1032	4.8%
Other values (4)	3831	17.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21636	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	3000	13.9%
l	2070	9.6%
e	1968	9.1%
t	1968	9.1%
C	1965	9.1%
r	1866	8.6%
d	1866	8.6%
E	1035	4.8%
w	1035	4.8%
s	1032	4.8%
Other values (4)	3831	17.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21636	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	3000	13.9%
l	2070	9.6%
e	1968	9.1%
t	1968	9.1%
C	1965	9.1%
r	1866	8.6%
d	1866	8.6%
E	1035	4.8%
w	1035	4.8%
s	1032	4.8%
Other values (4)	3831	17.7%

cogs
Real number (ℝ)

HIGH CORRELATION

Distinct	990
Distinct (%)	33.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	307.58738

Minimum	10.17
Maximum	993
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	10.17
5-th percentile	39.1145
Q1	118.4975
median	241.76
Q3	448.905
95-th percentile	783.33
Maximum	993
Range	982.83
Interquartile range (IQR)	330.4075

Descriptive statistics

Standard deviation	234.09841
Coefficient of variation (CV)	0.76107938
Kurtosis	-0.085613201
Mean	307.58738
Median Absolute Deviation (MAD)	150.175
Skewness	0.89167629
Sum	922762.14
Variance	54802.066
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
251.4	6	0.2%
789.6	6	0.2%
167.54	6	0.2%
263.76	6	0.2%
206.52	6	0.2%
207.27	6	0.2%
448.56	6	0.2%
89.28	6	0.2%
83.08	6	0.2%
180.09	6	0.2%
Other values (980)	2940	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10.17	3	0.1%
12.09	3	0.1%
12.54	3	0.1%
12.78	3	0.1%
13.98	3	0.1%
15.34	3	0.1%
15.43	3	0.1%
15.5	3	0.1%
16.28	3	0.1%
17.75	3	0.1%

Value	Count	Frequency (%)
993	3	0.1%
989.8	3	0.1%
985.2	3	0.1%
975	3	0.1%
973.8	3	0.1%
973.7	3	0.1%
972.1	3	0.1%
955.8	3	0.1%
954.4	3	0.1%
906.5	3	0.1%

gross_margin_percentage
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

4.761904762	3000

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	33000
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4.761904762
2nd row	4.761904762
3rd row	4.761904762
4th row	4.761904762
5th row	4.761904762

Common Values

Value	Count	Frequency (%)
4.761904762	3000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4.761904762	3000	100.0%

Most occurring characters

Value	Count	Frequency (%)
4	6000	18.2%
7	6000	18.2%
6	6000	18.2%
.	3000	9.1%
1	3000	9.1%
9	3000	9.1%
0	3000	9.1%
2	3000	9.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	33000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	6000	18.2%
7	6000	18.2%
6	6000	18.2%
.	3000	9.1%
1	3000	9.1%
9	3000	9.1%
0	3000	9.1%
2	3000	9.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	33000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	6000	18.2%
7	6000	18.2%
6	6000	18.2%
.	3000	9.1%
1	3000	9.1%
9	3000	9.1%
0	3000	9.1%
2	3000	9.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	33000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	6000	18.2%
7	6000	18.2%
6	6000	18.2%
.	3000	9.1%
1	3000	9.1%
9	3000	9.1%
0	3000	9.1%
2	3000	9.1%

gross_income
Real number (ℝ)

HIGH CORRELATION

Distinct	990
Distinct (%)	33.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.379369

Minimum	0.5085
Maximum	49.65
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	0.5085
5-th percentile	1.955725
Q1	5.924875
median	12.088
Q3	22.44525
95-th percentile	39.1665
Maximum	49.65
Range	49.1415
Interquartile range (IQR)	16.520375

Descriptive statistics

Standard deviation	11.704921
Coefficient of variation (CV)	0.76107938
Kurtosis	-0.085613201
Mean	15.379369
Median Absolute Deviation (MAD)	7.50875
Skewness	0.89167629
Sum	46138.107
Variance	137.00517
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.57	6	0.2%
39.48	6	0.2%
8.377	6	0.2%
13.188	6	0.2%
10.326	6	0.2%
10.3635	6	0.2%
22.428	6	0.2%
4.464	6	0.2%
4.154	6	0.2%
9.0045	6	0.2%
Other values (980)	2940	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.5085	3	0.1%
0.6045	3	0.1%
0.627	3	0.1%
0.639	3	0.1%
0.699	3	0.1%
0.767	3	0.1%
0.7715	3	0.1%
0.775	3	0.1%
0.814	3	0.1%
0.8875	3	0.1%

Value	Count	Frequency (%)
49.65	3	0.1%
49.49	3	0.1%
49.26	3	0.1%
48.75	3	0.1%
48.69	3	0.1%
48.685	3	0.1%
48.605	3	0.1%
47.79	3	0.1%
47.72	3	0.1%
45.325	3	0.1%

rating
Real number (ℝ)

Distinct	61
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.9727

Minimum	4
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	4
5-th percentile	4.295
Q1	5.5
median	7
Q3	8.5
95-th percentile	9.7
Maximum	10
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.7180071
Coefficient of variation (CV)	0.24639052
Kurtosis	-1.1517503
Mean	6.9727
Median Absolute Deviation (MAD)	1.5
Skewness	0.0090006296
Sum	20918.1
Variance	2.9515486
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6	78	2.6%
6.6	72	2.4%
4.2	66	2.2%
9.5	66	2.2%
6.5	63	2.1%
8	63	2.1%
5	63	2.1%
6.2	63	2.1%
5.1	63	2.1%
8.7	60	2.0%
Other values (51)	2343	78.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	33	1.1%
4.1	51	1.7%
4.2	66	2.2%
4.3	54	1.8%
4.4	51	1.7%
4.5	51	1.7%
4.6	24	0.8%
4.7	36	1.2%
4.8	39	1.3%
4.9	54	1.8%

Value	Count	Frequency (%)
10	15	0.5%
9.9	48	1.6%
9.8	57	1.9%
9.7	42	1.4%
9.6	51	1.7%
9.5	66	2.2%
9.4	36	1.2%
9.3	48	1.6%
9.2	48	1.6%
9.1	42	1.4%

day_of_txn
Real number (ℝ)

Distinct	31
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.256

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	15
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.6906639
Coefficient of variation (CV)	0.56965548
Kurtosis	-1.2264564
Mean	15.256
Median Absolute Deviation (MAD)	8
Skewness	0.049699381
Sum	45768
Variance	75.52764
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
15	132	4.4%
25	126	4.2%
19	123	4.1%
5	123	4.1%
8	123	4.1%
2	120	4.0%
14	117	3.9%
26	117	3.9%
7	114	3.8%
27	114	3.8%
Other values (21)	1791	59.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	84	2.8%
2	120	4.0%
3	108	3.6%
4	87	2.9%
5	123	4.1%
6	99	3.3%
7	114	3.8%
8	123	4.1%
9	111	3.7%
10	96	3.2%

Value	Count	Frequency (%)
31	42	1.4%
30	60	2.0%
29	60	2.0%
28	90	3.0%
27	114	3.8%
26	117	3.9%
25	126	4.2%
24	99	3.3%
23	108	3.6%
22	84	2.8%

month_of_txn
Categorical

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

1	1056
3	1035
2	909

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	3000
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	2
3rd row	2
4th row	3
5th row	1

Common Values

Value	Count	Frequency (%)
1	1056	35.2%
3	1035	34.5%
2	909	30.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	1056	35.2%
3	1035	34.5%
2	909	30.3%

Most occurring characters

Value	Count	Frequency (%)
1	1056	35.2%
3	1035	34.5%
2	909	30.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	1056	35.2%
3	1035	34.5%
2	909	30.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	1056	35.2%
3	1035	34.5%
2	909	30.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	1056	35.2%
3	1035	34.5%
2	909	30.3%

year_of_txn
Categorical

UNIFORM

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

2021	1000
2019	1000
2020	1000

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	12000
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021
2nd row	2019
3rd row	2021
4th row	2019
5th row	2021

Common Values

Value	Count	Frequency (%)
2021	1000	33.3%
2019	1000	33.3%
2020	1000	33.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2021	1000	33.3%
2019	1000	33.3%
2020	1000	33.3%

Most occurring characters

Value	Count	Frequency (%)
2	5000	41.7%
0	4000	33.3%
1	2000	16.7%
9	1000	8.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	5000	41.7%
0	4000	33.3%
1	2000	16.7%
9	1000	8.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	5000	41.7%
0	4000	33.3%
1	2000	16.7%
9	1000	8.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	5000	41.7%
0	4000	33.3%
1	2000	16.7%
9	1000	8.3%

branch_name
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Canada	1020
Chile	996
US	984

Length

Max length	6
Median length	5
Mean length	4.356
Min length	2

Characters and Unicode

Total characters	13068
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	US
2nd row	US
3rd row	Chile
4th row	Canada
5th row	Canada

Common Values

Value	Count	Frequency (%)
Canada	1020	34.0%
Chile	996	33.2%
US	984	32.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
canada	1020	34.0%
chile	996	33.2%
us	984	32.8%

Most occurring characters

Value	Count	Frequency (%)
a	3060	23.4%
C	2016	15.4%
n	1020	7.8%
d	1020	7.8%
h	996	7.6%
i	996	7.6%
l	996	7.6%
e	996	7.6%
U	984	7.5%
S	984	7.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	13068	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	3060	23.4%
C	2016	15.4%
n	1020	7.8%
d	1020	7.8%
h	996	7.6%
i	996	7.6%
l	996	7.6%
e	996	7.6%
U	984	7.5%
S	984	7.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	13068	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	3060	23.4%
C	2016	15.4%
n	1020	7.8%
d	1020	7.8%
h	996	7.6%
i	996	7.6%
l	996	7.6%
e	996	7.6%
U	984	7.5%
S	984	7.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	13068	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	3060	23.4%
C	2016	15.4%
n	1020	7.8%
d	1020	7.8%
h	996	7.6%
i	996	7.6%
l	996	7.6%
e	996	7.6%
U	984	7.5%
S	984	7.5%

city_manager_first_name
Categorical

HIGH CORRELATION

Distinct	9
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Jorge	1011
Celeste	988
Malcolm	978
Lois	5
Frankie	4
Other values (4)	14

Length

Max length	8
Median length	7
Mean length	6.6486667
Min length	4

Characters and Unicode

Total characters	19946
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Malcolm
2nd row	Malcolm
3rd row	Celeste
4th row	Jorge
5th row	Jorge

Common Values

Value	Count	Frequency (%)
Jorge	1011	33.7%
Celeste	988	32.9%
Malcolm	978	32.6%
Lois	5	0.2%
Frankie	4	0.1%
Kelvin	4	0.1%
Joseph	4	0.1%
Mark	3	0.1%
David	3	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
jorge	1011	33.7%
celeste	988	32.9%
malcolm	978	32.6%
lois	5	0.2%
frankie	4	0.1%
kelvin	4	0.1%
joseph	4	0.1%
mark	3	0.1%
david	3	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	3987	20.0%
l	2948	14.8%
o	1998	10.0%
r	1018	5.1%
J	1015	5.1%
g	1011	5.1%
	1006	5.0%
s	997	5.0%
C	988	5.0%
t	988	5.0%
Other values (15)	3990	20.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	19946	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	3987	20.0%
l	2948	14.8%
o	1998	10.0%
r	1018	5.1%
J	1015	5.1%
g	1011	5.1%
	1006	5.0%
s	997	5.0%
C	988	5.0%
t	988	5.0%
Other values (15)	3990	20.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	19946	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	3987	20.0%
l	2948	14.8%
o	1998	10.0%
r	1018	5.1%
J	1015	5.1%
g	1011	5.1%
	1006	5.0%
s	997	5.0%
C	988	5.0%
t	988	5.0%
Other values (15)	3990	20.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	19946	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	3987	20.0%
l	2948	14.8%
o	1998	10.0%
r	1018	5.1%
J	1015	5.1%
g	1011	5.1%
	1006	5.0%
s	997	5.0%
C	988	5.0%
t	988	5.0%
Other values (15)	3990	20.0%

city_manager_last_name
Categorical

HIGH CORRELATION

Distinct	9
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Floyd	1011
Webster	988
Newman	978
Jones	5
Murphie	4
Other values (4)	14

Length

Max length	7
Median length	6
Mean length	5.9896667
Min length	5

Characters and Unicode

Total characters	17969
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Newman
2nd row	Newman
3rd row	Webster
4th row	Floyd
5th row	Floyd

Common Values

Value	Count	Frequency (%)
Floyd	1011	33.7%
Webster	988	32.9%
Newman	978	32.6%
Jones	5	0.2%
Murphie	4	0.1%
Finch	4	0.1%
Almeco	4	0.1%
Brown	3	0.1%
Mallie	3	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
floyd	1011	33.7%
webster	988	32.9%
newman	978	32.6%
jones	5	0.2%
murphie	4	0.1%
finch	4	0.1%
almeco	4	0.1%
brown	3	0.1%
mallie	3	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	2970	16.5%
o	1023	5.7%
l	1021	5.7%
F	1015	5.6%
y	1011	5.6%
d	1011	5.6%
r	995	5.5%
s	993	5.5%
n	990	5.5%
W	988	5.5%
Other values (15)	5952	33.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17969	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	2970	16.5%
o	1023	5.7%
l	1021	5.7%
F	1015	5.6%
y	1011	5.6%
d	1011	5.6%
r	995	5.5%
s	993	5.5%
n	990	5.5%
W	988	5.5%
Other values (15)	5952	33.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17969	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	2970	16.5%
o	1023	5.7%
l	1021	5.7%
F	1015	5.6%
y	1011	5.6%
d	1011	5.6%
r	995	5.5%
s	993	5.5%
n	990	5.5%
W	988	5.5%
Other values (15)	5952	33.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17969	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	2970	16.5%
o	1023	5.7%
l	1021	5.7%
F	1015	5.6%
y	1011	5.6%
d	1011	5.6%
r	995	5.5%
s	993	5.5%
n	990	5.5%
W	988	5.5%
Other values (15)	5952	33.1%

product_code
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

FA	534
FB	522
EA	510
ST	498
HL	480

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	6000
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EA
2nd row	EA
3rd row	EA
4th row	EA
5th row	EA

Common Values

Value	Count	Frequency (%)
FA	534	17.8%
FB	522	17.4%
EA	510	17.0%
ST	498	16.6%
HL	480	16.0%
HB	456	15.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
fa	534	17.8%
fb	522	17.4%
ea	510	17.0%
st	498	16.6%
hl	480	16.0%
hb	456	15.2%

Most occurring characters

Value	Count	Frequency (%)
F	1056	17.6%
A	1044	17.4%
B	978	16.3%
H	936	15.6%
E	510	8.5%
S	498	8.3%
T	498	8.3%
L	480	8.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
F	1056	17.6%
A	1044	17.4%
B	978	16.3%
H	936	15.6%
E	510	8.5%
S	498	8.3%
T	498	8.3%
L	480	8.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
F	1056	17.6%
A	1044	17.4%
B	978	16.3%
H	936	15.6%
E	510	8.5%
S	498	8.3%
T	498	8.3%
L	480	8.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
F	1056	17.6%
A	1044	17.4%
B	978	16.3%
H	936	15.6%
E	510	8.5%
S	498	8.3%
T	498	8.3%
L	480	8.0%

manager_name
Categorical

HIGH CORRELATION

Distinct	9
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	23.6 KiB

Jorge Floyd	1011
Celeste Webster	988
Malcolm Newman	978
Lois Jones	5
Frankie Murphie	4
Other values (4)	14

Length

Max length	16
Median length	14
Mean length	13.638333
Min length	10

Characters and Unicode

Total characters	40915
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Malcolm Newman
2nd row	Malcolm Newman
3rd row	Celeste Webster
4th row	Jorge Floyd
5th row	Jorge Floyd

Common Values

Value	Count	Frequency (%)
Jorge Floyd	1011	33.7%
Celeste Webster	988	32.9%
Malcolm Newman	978	32.6%
Lois Jones	5	0.2%
Frankie Murphie	4	0.1%
Kelvin Finch	4	0.1%
Joseph Almeco	4	0.1%
Mark Brown	3	0.1%
David Mallie	3	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
jorge	1011	16.9%
floyd	1011	16.9%
celeste	988	16.5%
webster	988	16.5%
malcolm	978	16.3%
newman	978	16.3%
lois	5	0.1%
jones	5	0.1%
finch	4	0.1%
almeco	4	0.1%
Other values (8)	28	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	6957	17.0%
	4006	9.8%
l	3969	9.7%
o	3021	7.4%
r	2013	4.9%
s	1990	4.9%
t	1976	4.8%
a	1969	4.8%
m	1960	4.8%
J	1020	2.5%
Other values (23)	12034	29.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	40915	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	6957	17.0%
	4006	9.8%
l	3969	9.7%
o	3021	7.4%
r	2013	4.9%
s	1990	4.9%
t	1976	4.8%
a	1969	4.8%
m	1960	4.8%
J	1020	2.5%
Other values (23)	12034	29.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	40915	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	6957	17.0%
	4006	9.8%
l	3969	9.7%
o	3021	7.4%
r	2013	4.9%
s	1990	4.9%
t	1976	4.8%
a	1969	4.8%
m	1960	4.8%
J	1020	2.5%
Other values (23)	12034	29.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	40915	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	6957	17.0%
	4006	9.8%
l	3969	9.7%
o	3021	7.4%
r	2013	4.9%
s	1990	4.9%
t	1976	4.8%
a	1969	4.8%
m	1960	4.8%
J	1020	2.5%
Other values (23)	12034	29.4%

Auto

Heatmap
Table

	branch	branch_name	city	city_manager_first_name	city_manager_last_name	cogs	customer_type	day_of_txn	gender	gross_income	manager_name	month_of_txn	payment	product_code	product_line	quantity	rating	tax_5%	total	unit_price	year_of_txn
branch	1.000	1.000	0.996	0.996	0.996	0.020	0.000	-0.013	0.054	0.020	0.996	0.033	0.031	0.064	0.064	0.016	0.009	0.020	0.020	0.029	0.000
branch_name	1.000	1.000	0.996	0.996	0.996	0.020	0.000	-0.013	0.054	0.020	0.996	0.033	0.031	0.064	0.064	0.016	0.009	0.020	0.020	0.029	0.000
city	0.996	0.996	1.000	1.000	1.000	-0.010	0.021	0.006	0.045	-0.010	1.000	0.043	0.044	0.036	0.036	-0.005	0.045	-0.010	-0.010	-0.017	0.066
city_manager_first_name	0.996	0.996	1.000	1.000	1.000	0.017	0.021	-0.008	0.045	0.017	1.000	0.043	0.044	0.036	0.036	0.018	0.060	0.017	0.017	0.014	0.066
city_manager_last_name	0.996	0.996	1.000	1.000	1.000	0.001	0.021	-0.004	0.045	0.001	1.000	0.043	0.044	0.036	0.036	-0.006	-0.049	0.001	0.001	0.015	0.066
cogs	0.020	0.020	-0.010	0.017	0.001	1.000	0.047	0.002	0.074	1.000	0.042	0.055	0.068	0.056	0.056	0.735	-0.017	1.000	1.000	0.630	0.000
customer_type	0.000	0.000	0.021	0.021	0.021	0.047	1.000	0.034	0.035	-0.017	0.021	0.042	0.067	0.041	0.041	-0.016	0.019	-0.017	-0.017	-0.019	0.000
day_of_txn	-0.013	-0.013	0.006	-0.008	-0.004	0.002	0.034	1.000	0.057	0.002	0.035	0.148	0.090	0.083	0.083	-0.043	-0.009	0.002	0.002	0.057	0.000
gender	0.054	0.054	0.045	0.045	0.045	0.074	0.035	0.057	1.000	-0.052	0.045	0.054	0.048	0.064	0.064	-0.074	0.004	-0.052	-0.052	0.016	0.000
gross_income	0.020	0.020	-0.010	0.017	0.001	1.000	-0.017	0.002	-0.052	1.000	0.042	0.055	0.068	0.056	0.056	0.735	-0.017	1.000	1.000	0.630	0.000
manager_name	0.996	0.996	1.000	1.000	1.000	0.042	0.021	0.035	0.045	0.042	1.000	0.043	0.044	0.036	0.036	0.018	0.060	0.017	0.017	0.014	0.066
month_of_txn	0.033	0.033	0.043	0.043	0.043	0.055	0.042	0.148	0.054	0.055	0.043	1.000	0.022	0.069	0.069	-0.015	-0.042	-0.023	-0.023	-0.026	0.000
payment	0.031	0.031	0.044	0.044	0.044	0.068	0.067	0.090	0.048	0.068	0.044	0.022	1.000	0.052	0.052	-0.004	-0.005	-0.011	-0.011	-0.015	0.000
product_code	0.064	0.064	0.036	0.036	0.036	0.056	0.041	0.083	0.064	0.056	0.036	0.069	0.052	1.000	1.000	0.020	-0.019	0.036	0.036	0.019	0.000
product_line	0.064	0.064	0.036	0.036	0.036	0.056	0.041	0.083	0.064	0.056	0.036	0.069	0.052	1.000	1.000	0.020	-0.019	0.036	0.036	0.019	0.000
quantity	0.016	0.016	-0.005	0.018	-0.006	0.735	-0.016	-0.043	-0.074	0.735	0.018	-0.015	-0.004	0.020	0.020	1.000	-0.015	0.735	0.735	0.011	0.000
rating	0.009	0.009	0.045	0.060	-0.049	-0.017	0.019	-0.009	0.004	-0.017	0.060	-0.042	-0.005	-0.019	-0.019	-0.015	1.000	-0.017	-0.017	-0.008	0.000
tax_5%	0.020	0.020	-0.010	0.017	0.001	1.000	-0.017	0.002	-0.052	1.000	0.017	-0.023	-0.011	0.036	0.036	0.735	-0.017	1.000	1.000	0.630	0.000
total	0.020	0.020	-0.010	0.017	0.001	1.000	-0.017	0.002	-0.052	1.000	0.017	-0.023	-0.011	0.036	0.036	0.735	-0.017	1.000	1.000	0.630	0.000
unit_price	0.029	0.029	-0.017	0.014	0.015	0.630	-0.019	0.057	0.016	0.630	0.014	-0.026	-0.015	0.019	0.019	0.011	-0.008	0.630	0.630	1.000	0.000
year_of_txn	0.000	0.000	0.066	0.066	0.066	0.000	0.000	0.000	0.000	0.000	0.066	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	invoice_id	branch	city	customer_type	gender	product_line	unit_price	quantity	tax_5%	total	time	payment	cogs	gross_margin_percentage	gross_income	rating	day_of_txn	month_of_txn	year_of_txn	branch_name	city_manager_first_name	city_manager_last_name	product_code	manager_name
0	155-45-3814	C	Naypyitaw	Member	Female	Electronic accessories	88.55	8	35.4200	743.8200	15:29:00	Ewallet	708.40	4.761905	35.4200	4.7	19	3	2021	US	Malcolm	Newman	EA	Malcolm Newman
1	810-60-6344	C	Naypyitaw	Normal	Female	Electronic accessories	40.86	8	16.3440	343.2240	14:38:00	Credit card	326.88	4.761905	16.3440	6.5	7	2	2019	US	Malcolm	Newman	EA	Malcolm Newman
2	431-66-2305	B	Mandalay	Normal	Female	Electronic accessories	88.25	9	39.7125	833.9625	20:51:00	Credit card	794.25	4.761905	39.7125	7.6	15	2	2021	Chile	Celeste	Webster	EA	Celeste Webster
3	189-52-0236	A	Yangon	Normal	Male	Electronic accessories	99.55	7	34.8425	731.6925	12:07:00	Cash	696.85	4.761905	34.8425	7.6	14	3	2019	Canada	Jorge	Floyd	EA	Jorge Floyd
4	575-67-1508	A	Yangon	Normal	Male	Electronic accessories	38.60	1	1.9300	40.5300	11:26:00	Ewallet	38.60	4.761905	1.9300	6.7	29	1	2021	Canada	Jorge	Floyd	EA	Jorge Floyd
5	250-81-7186	C	Naypyitaw	Normal	Female	Electronic accessories	99.69	1	4.9845	104.6745	10:23:00	Credit card	99.69	4.761905	4.9845	8.0	27	2	2019	US	Malcolm	Newman	EA	Malcolm Newman
6	416-17-9926	A	Yangon	Member	Female	Electronic accessories	74.22	10	37.1100	779.3100	14:42:00	Credit card	742.20	4.761905	37.1100	4.3	1	1	2021	Canada	Jorge	Floyd	EA	Jorge Floyd
7	740-11-5257	C	Naypyitaw	Normal	Male	Electronic accessories	24.74	10	12.3700	259.7700	16:44:00	Cash	247.40	4.761905	12.3700	7.1	24	2	2019	US	Malcolm	Newman	EA	Malcolm Newman
8	794-32-2436	B	Mandalay	Member	Male	Electronic accessories	55.67	2	5.5670	116.9070	15:08:00	Ewallet	111.34	4.761905	5.5670	6.0	27	3	2021	Chile	Celeste	Webster	EA	Celeste Webster
9	676-39-6028	A	Yangon	Member	Female	Electronic accessories	64.44	5	16.1100	338.3100	17:04:00	Cash	322.20	4.761905	16.1100	6.6	30	3	2021	Canada	Jorge	Floyd	EA	Jorge Floyd

	invoice_id	branch	city	customer_type	gender	product_line	unit_price	quantity	tax_5%	total	time	payment	cogs	gross_margin_percentage	gross_income	rating	day_of_txn	month_of_txn	year_of_txn	branch_name	city_manager_first_name	city_manager_last_name	product_code	manager_name
2990	343-75-9322	B	Mandalay	Member	Female	Sports and travel	11.85	8	4.7400	99.5400	16:34:00	Cash	94.80	4.761905	4.7400	4.1	9	1	2021	Chile	Celeste	Webster	ST	Celeste Webster
2991	670-71-7306	B	Mandalay	Normal	Male	Sports and travel	44.63	6	13.3890	281.1690	20:08:00	Credit card	267.78	4.761905	13.3890	5.1	2	1	2021	Chile	Celeste	Webster	ST	Celeste Webster
2992	321-49-7382	B	Mandalay	Member	Male	Sports and travel	88.31	1	4.4155	92.7255	17:38:00	Credit card	88.31	4.761905	4.4155	5.2	15	2	2020	Chile	Celeste	Webster	ST	Celeste Webster
2993	361-59-0574	B	Mandalay	Member	Male	Sports and travel	90.53	8	36.2120	760.4520	14:48:00	Credit card	724.24	4.761905	36.2120	6.5	15	3	2021	Chile	Celeste	Webster	ST	Celeste Webster
2994	311-13-6971	B	Mandalay	Member	Male	Sports and travel	31.99	10	15.9950	335.8950	15:18:00	Credit card	319.90	4.761905	15.9950	9.9	20	2	2020	Chile	Celeste	Webster	ST	Celeste Webster
2995	361-59-0574	B	Mandalay	Member	Male	Sports and travel	90.53	8	36.2120	760.4520	14:48:00	Credit card	724.24	4.761905	36.2120	6.5	15	3	2020	Chile	Celeste	Webster	ST	Celeste Webster
2996	311-13-6971	B	Mandalay	Member	Male	Sports and travel	31.99	10	15.9950	335.8950	15:18:00	Credit card	319.90	4.761905	15.9950	9.9	20	2	2021	Chile	Celeste	Webster	ST	Celeste Webster
2997	670-71-7306	B	Mandalay	Normal	Male	Sports and travel	44.63	6	13.3890	281.1690	20:08:00	Credit card	267.78	4.761905	13.3890	5.1	2	1	2020	Chile	Celeste	Webster	ST	Celeste Webster
2998	253-12-6086	A	Yangon	Member	Female	Sports and travel	98.40	7	34.4400	723.2400	12:43:00	Credit card	688.80	4.761905	34.4400	8.7	12	3	2020	Canada	Jorge	Floyd	ST	Jorge Floyd
2999	343-75-9322	B	Mandalay	Member	Female	Sports and travel	11.85	8	4.7400	99.5400	16:34:00	Cash	94.80	4.761905	4.7400	4.1	9	1	2020	Chile	Celeste	Webster	ST	Celeste Webster

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)